1. Install the free report writing tool that works with your version of SQL Server:
□ Microsoft SQL Server 2008 R2 Report Builder 3.0
□ Microsoft SQL Server 2005 Express Edition Toolkit, which installs SQL Server Business Intelligence Development Studio (BIDS)
2. Reuse or copy reports created in other editions. When you publish a report created in an earlier version of Reporting Services, it upgrades to the newer format.
3. Create reports using any Reporting Service features: drill-through reports, sub-reports, and parameterized reports that include charts, tables, matrices, and lists.
4. Publish to a report server. To make a published report available to users, use Report Manager to create role assignments that grant access to it.